package com.weimall.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ZzdZbExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ZzdZbExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRqIsNull() {
            addCriterion("RQ is null");
            return (Criteria) this;
        }

        public Criteria andRqIsNotNull() {
            addCriterion("RQ is not null");
            return (Criteria) this;
        }

        public Criteria andRqEqualTo(Date value) {
            addCriterion("RQ =", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqNotEqualTo(Date value) {
            addCriterion("RQ <>", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqGreaterThan(Date value) {
            addCriterion("RQ >", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqGreaterThanOrEqualTo(Date value) {
            addCriterion("RQ >=", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqLessThan(Date value) {
            addCriterion("RQ <", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqLessThanOrEqualTo(Date value) {
            addCriterion("RQ <=", value, "rq");
            return (Criteria) this;
        }

        public Criteria andRqIn(List<Date> values) {
            addCriterion("RQ in", values, "rq");
            return (Criteria) this;
        }

        public Criteria andRqNotIn(List<Date> values) {
            addCriterion("RQ not in", values, "rq");
            return (Criteria) this;
        }

        public Criteria andRqBetween(Date value1, Date value2) {
            addCriterion("RQ between", value1, value2, "rq");
            return (Criteria) this;
        }

        public Criteria andRqNotBetween(Date value1, Date value2) {
            addCriterion("RQ not between", value1, value2, "rq");
            return (Criteria) this;
        }

        public Criteria andJbrbmIsNull() {
            addCriterion("JBRBM is null");
            return (Criteria) this;
        }

        public Criteria andJbrbmIsNotNull() {
            addCriterion("JBRBM is not null");
            return (Criteria) this;
        }

        public Criteria andJbrbmEqualTo(String value) {
            addCriterion("JBRBM =", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotEqualTo(String value) {
            addCriterion("JBRBM <>", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmGreaterThan(String value) {
            addCriterion("JBRBM >", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmGreaterThanOrEqualTo(String value) {
            addCriterion("JBRBM >=", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmLessThan(String value) {
            addCriterion("JBRBM <", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmLessThanOrEqualTo(String value) {
            addCriterion("JBRBM <=", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmLike(String value) {
            addCriterion("JBRBM like", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotLike(String value) {
            addCriterion("JBRBM not like", value, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmIn(List<String> values) {
            addCriterion("JBRBM in", values, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotIn(List<String> values) {
            addCriterion("JBRBM not in", values, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmBetween(String value1, String value2) {
            addCriterion("JBRBM between", value1, value2, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrbmNotBetween(String value1, String value2) {
            addCriterion("JBRBM not between", value1, value2, "jbrbm");
            return (Criteria) this;
        }

        public Criteria andJbrmcIsNull() {
            addCriterion("JBRMC is null");
            return (Criteria) this;
        }

        public Criteria andJbrmcIsNotNull() {
            addCriterion("JBRMC is not null");
            return (Criteria) this;
        }

        public Criteria andJbrmcEqualTo(String value) {
            addCriterion("JBRMC =", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotEqualTo(String value) {
            addCriterion("JBRMC <>", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcGreaterThan(String value) {
            addCriterion("JBRMC >", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcGreaterThanOrEqualTo(String value) {
            addCriterion("JBRMC >=", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcLessThan(String value) {
            addCriterion("JBRMC <", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcLessThanOrEqualTo(String value) {
            addCriterion("JBRMC <=", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcLike(String value) {
            addCriterion("JBRMC like", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotLike(String value) {
            addCriterion("JBRMC not like", value, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcIn(List<String> values) {
            addCriterion("JBRMC in", values, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotIn(List<String> values) {
            addCriterion("JBRMC not in", values, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcBetween(String value1, String value2) {
            addCriterion("JBRMC between", value1, value2, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andJbrmcNotBetween(String value1, String value2) {
            addCriterion("JBRMC not between", value1, value2, "jbrmc");
            return (Criteria) this;
        }

        public Criteria andZdrIsNull() {
            addCriterion("ZDR is null");
            return (Criteria) this;
        }

        public Criteria andZdrIsNotNull() {
            addCriterion("ZDR is not null");
            return (Criteria) this;
        }

        public Criteria andZdrEqualTo(String value) {
            addCriterion("ZDR =", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotEqualTo(String value) {
            addCriterion("ZDR <>", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrGreaterThan(String value) {
            addCriterion("ZDR >", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrGreaterThanOrEqualTo(String value) {
            addCriterion("ZDR >=", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrLessThan(String value) {
            addCriterion("ZDR <", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrLessThanOrEqualTo(String value) {
            addCriterion("ZDR <=", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrLike(String value) {
            addCriterion("ZDR like", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotLike(String value) {
            addCriterion("ZDR not like", value, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrIn(List<String> values) {
            addCriterion("ZDR in", values, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotIn(List<String> values) {
            addCriterion("ZDR not in", values, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrBetween(String value1, String value2) {
            addCriterion("ZDR between", value1, value2, "zdr");
            return (Criteria) this;
        }

        public Criteria andZdrNotBetween(String value1, String value2) {
            addCriterion("ZDR not between", value1, value2, "zdr");
            return (Criteria) this;
        }

        public Criteria andShrIsNull() {
            addCriterion("SHR is null");
            return (Criteria) this;
        }

        public Criteria andShrIsNotNull() {
            addCriterion("SHR is not null");
            return (Criteria) this;
        }

        public Criteria andShrEqualTo(String value) {
            addCriterion("SHR =", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotEqualTo(String value) {
            addCriterion("SHR <>", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrGreaterThan(String value) {
            addCriterion("SHR >", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrGreaterThanOrEqualTo(String value) {
            addCriterion("SHR >=", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrLessThan(String value) {
            addCriterion("SHR <", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrLessThanOrEqualTo(String value) {
            addCriterion("SHR <=", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrLike(String value) {
            addCriterion("SHR like", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotLike(String value) {
            addCriterion("SHR not like", value, "shr");
            return (Criteria) this;
        }

        public Criteria andShrIn(List<String> values) {
            addCriterion("SHR in", values, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotIn(List<String> values) {
            addCriterion("SHR not in", values, "shr");
            return (Criteria) this;
        }

        public Criteria andShrBetween(String value1, String value2) {
            addCriterion("SHR between", value1, value2, "shr");
            return (Criteria) this;
        }

        public Criteria andShrNotBetween(String value1, String value2) {
            addCriterion("SHR not between", value1, value2, "shr");
            return (Criteria) this;
        }

        public Criteria andPzhIsNull() {
            addCriterion("PZH is null");
            return (Criteria) this;
        }

        public Criteria andPzhIsNotNull() {
            addCriterion("PZH is not null");
            return (Criteria) this;
        }

        public Criteria andPzhEqualTo(String value) {
            addCriterion("PZH =", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotEqualTo(String value) {
            addCriterion("PZH <>", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhGreaterThan(String value) {
            addCriterion("PZH >", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhGreaterThanOrEqualTo(String value) {
            addCriterion("PZH >=", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhLessThan(String value) {
            addCriterion("PZH <", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhLessThanOrEqualTo(String value) {
            addCriterion("PZH <=", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhLike(String value) {
            addCriterion("PZH like", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotLike(String value) {
            addCriterion("PZH not like", value, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhIn(List<String> values) {
            addCriterion("PZH in", values, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotIn(List<String> values) {
            addCriterion("PZH not in", values, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhBetween(String value1, String value2) {
            addCriterion("PZH between", value1, value2, "pzh");
            return (Criteria) this;
        }

        public Criteria andPzhNotBetween(String value1, String value2) {
            addCriterion("PZH not between", value1, value2, "pzh");
            return (Criteria) this;
        }

        public Criteria andZphIsNull() {
            addCriterion("ZPH is null");
            return (Criteria) this;
        }

        public Criteria andZphIsNotNull() {
            addCriterion("ZPH is not null");
            return (Criteria) this;
        }

        public Criteria andZphEqualTo(String value) {
            addCriterion("ZPH =", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphNotEqualTo(String value) {
            addCriterion("ZPH <>", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphGreaterThan(String value) {
            addCriterion("ZPH >", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphGreaterThanOrEqualTo(String value) {
            addCriterion("ZPH >=", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphLessThan(String value) {
            addCriterion("ZPH <", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphLessThanOrEqualTo(String value) {
            addCriterion("ZPH <=", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphLike(String value) {
            addCriterion("ZPH like", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphNotLike(String value) {
            addCriterion("ZPH not like", value, "zph");
            return (Criteria) this;
        }

        public Criteria andZphIn(List<String> values) {
            addCriterion("ZPH in", values, "zph");
            return (Criteria) this;
        }

        public Criteria andZphNotIn(List<String> values) {
            addCriterion("ZPH not in", values, "zph");
            return (Criteria) this;
        }

        public Criteria andZphBetween(String value1, String value2) {
            addCriterion("ZPH between", value1, value2, "zph");
            return (Criteria) this;
        }

        public Criteria andZphNotBetween(String value1, String value2) {
            addCriterion("ZPH not between", value1, value2, "zph");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmIsNull() {
            addCriterion("ZC_KM1BM is null");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmIsNotNull() {
            addCriterion("ZC_KM1BM is not null");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmEqualTo(String value) {
            addCriterion("ZC_KM1BM =", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmNotEqualTo(String value) {
            addCriterion("ZC_KM1BM <>", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmGreaterThan(String value) {
            addCriterion("ZC_KM1BM >", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmGreaterThanOrEqualTo(String value) {
            addCriterion("ZC_KM1BM >=", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmLessThan(String value) {
            addCriterion("ZC_KM1BM <", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmLessThanOrEqualTo(String value) {
            addCriterion("ZC_KM1BM <=", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmLike(String value) {
            addCriterion("ZC_KM1BM like", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmNotLike(String value) {
            addCriterion("ZC_KM1BM not like", value, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmIn(List<String> values) {
            addCriterion("ZC_KM1BM in", values, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmNotIn(List<String> values) {
            addCriterion("ZC_KM1BM not in", values, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmBetween(String value1, String value2) {
            addCriterion("ZC_KM1BM between", value1, value2, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm1bmNotBetween(String value1, String value2) {
            addCriterion("ZC_KM1BM not between", value1, value2, "zcKm1bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmIsNull() {
            addCriterion("ZC_KM2BM is null");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmIsNotNull() {
            addCriterion("ZC_KM2BM is not null");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmEqualTo(String value) {
            addCriterion("ZC_KM2BM =", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmNotEqualTo(String value) {
            addCriterion("ZC_KM2BM <>", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmGreaterThan(String value) {
            addCriterion("ZC_KM2BM >", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmGreaterThanOrEqualTo(String value) {
            addCriterion("ZC_KM2BM >=", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmLessThan(String value) {
            addCriterion("ZC_KM2BM <", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmLessThanOrEqualTo(String value) {
            addCriterion("ZC_KM2BM <=", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmLike(String value) {
            addCriterion("ZC_KM2BM like", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmNotLike(String value) {
            addCriterion("ZC_KM2BM not like", value, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmIn(List<String> values) {
            addCriterion("ZC_KM2BM in", values, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmNotIn(List<String> values) {
            addCriterion("ZC_KM2BM not in", values, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmBetween(String value1, String value2) {
            addCriterion("ZC_KM2BM between", value1, value2, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm2bmNotBetween(String value1, String value2) {
            addCriterion("ZC_KM2BM not between", value1, value2, "zcKm2bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmIsNull() {
            addCriterion("ZC_KM3BM is null");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmIsNotNull() {
            addCriterion("ZC_KM3BM is not null");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmEqualTo(String value) {
            addCriterion("ZC_KM3BM =", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmNotEqualTo(String value) {
            addCriterion("ZC_KM3BM <>", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmGreaterThan(String value) {
            addCriterion("ZC_KM3BM >", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmGreaterThanOrEqualTo(String value) {
            addCriterion("ZC_KM3BM >=", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmLessThan(String value) {
            addCriterion("ZC_KM3BM <", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmLessThanOrEqualTo(String value) {
            addCriterion("ZC_KM3BM <=", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmLike(String value) {
            addCriterion("ZC_KM3BM like", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmNotLike(String value) {
            addCriterion("ZC_KM3BM not like", value, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmIn(List<String> values) {
            addCriterion("ZC_KM3BM in", values, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmNotIn(List<String> values) {
            addCriterion("ZC_KM3BM not in", values, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmBetween(String value1, String value2) {
            addCriterion("ZC_KM3BM between", value1, value2, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKm3bmNotBetween(String value1, String value2) {
            addCriterion("ZC_KM3BM not between", value1, value2, "zcKm3bm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmIsNull() {
            addCriterion("ZC_KMBM is null");
            return (Criteria) this;
        }

        public Criteria andZcKmbmIsNotNull() {
            addCriterion("ZC_KMBM is not null");
            return (Criteria) this;
        }

        public Criteria andZcKmbmEqualTo(String value) {
            addCriterion("ZC_KMBM =", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmNotEqualTo(String value) {
            addCriterion("ZC_KMBM <>", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmGreaterThan(String value) {
            addCriterion("ZC_KMBM >", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmGreaterThanOrEqualTo(String value) {
            addCriterion("ZC_KMBM >=", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmLessThan(String value) {
            addCriterion("ZC_KMBM <", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmLessThanOrEqualTo(String value) {
            addCriterion("ZC_KMBM <=", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmLike(String value) {
            addCriterion("ZC_KMBM like", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmNotLike(String value) {
            addCriterion("ZC_KMBM not like", value, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmIn(List<String> values) {
            addCriterion("ZC_KMBM in", values, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmNotIn(List<String> values) {
            addCriterion("ZC_KMBM not in", values, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmBetween(String value1, String value2) {
            addCriterion("ZC_KMBM between", value1, value2, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmbmNotBetween(String value1, String value2) {
            addCriterion("ZC_KMBM not between", value1, value2, "zcKmbm");
            return (Criteria) this;
        }

        public Criteria andZcKmmcIsNull() {
            addCriterion("ZC_KMMC is null");
            return (Criteria) this;
        }

        public Criteria andZcKmmcIsNotNull() {
            addCriterion("ZC_KMMC is not null");
            return (Criteria) this;
        }

        public Criteria andZcKmmcEqualTo(String value) {
            addCriterion("ZC_KMMC =", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcNotEqualTo(String value) {
            addCriterion("ZC_KMMC <>", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcGreaterThan(String value) {
            addCriterion("ZC_KMMC >", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcGreaterThanOrEqualTo(String value) {
            addCriterion("ZC_KMMC >=", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcLessThan(String value) {
            addCriterion("ZC_KMMC <", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcLessThanOrEqualTo(String value) {
            addCriterion("ZC_KMMC <=", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcLike(String value) {
            addCriterion("ZC_KMMC like", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcNotLike(String value) {
            addCriterion("ZC_KMMC not like", value, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcIn(List<String> values) {
            addCriterion("ZC_KMMC in", values, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcNotIn(List<String> values) {
            addCriterion("ZC_KMMC not in", values, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcBetween(String value1, String value2) {
            addCriterion("ZC_KMMC between", value1, value2, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmmcNotBetween(String value1, String value2) {
            addCriterion("ZC_KMMC not between", value1, value2, "zcKmmc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcIsNull() {
            addCriterion("ZC_KMQC is null");
            return (Criteria) this;
        }

        public Criteria andZcKmqcIsNotNull() {
            addCriterion("ZC_KMQC is not null");
            return (Criteria) this;
        }

        public Criteria andZcKmqcEqualTo(String value) {
            addCriterion("ZC_KMQC =", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcNotEqualTo(String value) {
            addCriterion("ZC_KMQC <>", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcGreaterThan(String value) {
            addCriterion("ZC_KMQC >", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcGreaterThanOrEqualTo(String value) {
            addCriterion("ZC_KMQC >=", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcLessThan(String value) {
            addCriterion("ZC_KMQC <", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcLessThanOrEqualTo(String value) {
            addCriterion("ZC_KMQC <=", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcLike(String value) {
            addCriterion("ZC_KMQC like", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcNotLike(String value) {
            addCriterion("ZC_KMQC not like", value, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcIn(List<String> values) {
            addCriterion("ZC_KMQC in", values, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcNotIn(List<String> values) {
            addCriterion("ZC_KMQC not in", values, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcBetween(String value1, String value2) {
            addCriterion("ZC_KMQC between", value1, value2, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZcKmqcNotBetween(String value1, String value2) {
            addCriterion("ZC_KMQC not between", value1, value2, "zcKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmIsNull() {
            addCriterion("ZR_KM1BM is null");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmIsNotNull() {
            addCriterion("ZR_KM1BM is not null");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmEqualTo(String value) {
            addCriterion("ZR_KM1BM =", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmNotEqualTo(String value) {
            addCriterion("ZR_KM1BM <>", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmGreaterThan(String value) {
            addCriterion("ZR_KM1BM >", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmGreaterThanOrEqualTo(String value) {
            addCriterion("ZR_KM1BM >=", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmLessThan(String value) {
            addCriterion("ZR_KM1BM <", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmLessThanOrEqualTo(String value) {
            addCriterion("ZR_KM1BM <=", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmLike(String value) {
            addCriterion("ZR_KM1BM like", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmNotLike(String value) {
            addCriterion("ZR_KM1BM not like", value, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmIn(List<String> values) {
            addCriterion("ZR_KM1BM in", values, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmNotIn(List<String> values) {
            addCriterion("ZR_KM1BM not in", values, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmBetween(String value1, String value2) {
            addCriterion("ZR_KM1BM between", value1, value2, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm1bmNotBetween(String value1, String value2) {
            addCriterion("ZR_KM1BM not between", value1, value2, "zrKm1bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmIsNull() {
            addCriterion("ZR_KM2BM is null");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmIsNotNull() {
            addCriterion("ZR_KM2BM is not null");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmEqualTo(String value) {
            addCriterion("ZR_KM2BM =", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmNotEqualTo(String value) {
            addCriterion("ZR_KM2BM <>", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmGreaterThan(String value) {
            addCriterion("ZR_KM2BM >", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmGreaterThanOrEqualTo(String value) {
            addCriterion("ZR_KM2BM >=", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmLessThan(String value) {
            addCriterion("ZR_KM2BM <", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmLessThanOrEqualTo(String value) {
            addCriterion("ZR_KM2BM <=", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmLike(String value) {
            addCriterion("ZR_KM2BM like", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmNotLike(String value) {
            addCriterion("ZR_KM2BM not like", value, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmIn(List<String> values) {
            addCriterion("ZR_KM2BM in", values, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmNotIn(List<String> values) {
            addCriterion("ZR_KM2BM not in", values, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmBetween(String value1, String value2) {
            addCriterion("ZR_KM2BM between", value1, value2, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm2bmNotBetween(String value1, String value2) {
            addCriterion("ZR_KM2BM not between", value1, value2, "zrKm2bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmIsNull() {
            addCriterion("ZR_KM3BM is null");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmIsNotNull() {
            addCriterion("ZR_KM3BM is not null");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmEqualTo(String value) {
            addCriterion("ZR_KM3BM =", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmNotEqualTo(String value) {
            addCriterion("ZR_KM3BM <>", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmGreaterThan(String value) {
            addCriterion("ZR_KM3BM >", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmGreaterThanOrEqualTo(String value) {
            addCriterion("ZR_KM3BM >=", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmLessThan(String value) {
            addCriterion("ZR_KM3BM <", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmLessThanOrEqualTo(String value) {
            addCriterion("ZR_KM3BM <=", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmLike(String value) {
            addCriterion("ZR_KM3BM like", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmNotLike(String value) {
            addCriterion("ZR_KM3BM not like", value, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmIn(List<String> values) {
            addCriterion("ZR_KM3BM in", values, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmNotIn(List<String> values) {
            addCriterion("ZR_KM3BM not in", values, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmBetween(String value1, String value2) {
            addCriterion("ZR_KM3BM between", value1, value2, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKm3bmNotBetween(String value1, String value2) {
            addCriterion("ZR_KM3BM not between", value1, value2, "zrKm3bm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmIsNull() {
            addCriterion("ZR_KMBM is null");
            return (Criteria) this;
        }

        public Criteria andZrKmbmIsNotNull() {
            addCriterion("ZR_KMBM is not null");
            return (Criteria) this;
        }

        public Criteria andZrKmbmEqualTo(String value) {
            addCriterion("ZR_KMBM =", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmNotEqualTo(String value) {
            addCriterion("ZR_KMBM <>", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmGreaterThan(String value) {
            addCriterion("ZR_KMBM >", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmGreaterThanOrEqualTo(String value) {
            addCriterion("ZR_KMBM >=", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmLessThan(String value) {
            addCriterion("ZR_KMBM <", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmLessThanOrEqualTo(String value) {
            addCriterion("ZR_KMBM <=", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmLike(String value) {
            addCriterion("ZR_KMBM like", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmNotLike(String value) {
            addCriterion("ZR_KMBM not like", value, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmIn(List<String> values) {
            addCriterion("ZR_KMBM in", values, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmNotIn(List<String> values) {
            addCriterion("ZR_KMBM not in", values, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmBetween(String value1, String value2) {
            addCriterion("ZR_KMBM between", value1, value2, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmbmNotBetween(String value1, String value2) {
            addCriterion("ZR_KMBM not between", value1, value2, "zrKmbm");
            return (Criteria) this;
        }

        public Criteria andZrKmmcIsNull() {
            addCriterion("ZR_KMMC is null");
            return (Criteria) this;
        }

        public Criteria andZrKmmcIsNotNull() {
            addCriterion("ZR_KMMC is not null");
            return (Criteria) this;
        }

        public Criteria andZrKmmcEqualTo(String value) {
            addCriterion("ZR_KMMC =", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcNotEqualTo(String value) {
            addCriterion("ZR_KMMC <>", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcGreaterThan(String value) {
            addCriterion("ZR_KMMC >", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcGreaterThanOrEqualTo(String value) {
            addCriterion("ZR_KMMC >=", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcLessThan(String value) {
            addCriterion("ZR_KMMC <", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcLessThanOrEqualTo(String value) {
            addCriterion("ZR_KMMC <=", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcLike(String value) {
            addCriterion("ZR_KMMC like", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcNotLike(String value) {
            addCriterion("ZR_KMMC not like", value, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcIn(List<String> values) {
            addCriterion("ZR_KMMC in", values, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcNotIn(List<String> values) {
            addCriterion("ZR_KMMC not in", values, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcBetween(String value1, String value2) {
            addCriterion("ZR_KMMC between", value1, value2, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmmcNotBetween(String value1, String value2) {
            addCriterion("ZR_KMMC not between", value1, value2, "zrKmmc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcIsNull() {
            addCriterion("ZR_KMQC is null");
            return (Criteria) this;
        }

        public Criteria andZrKmqcIsNotNull() {
            addCriterion("ZR_KMQC is not null");
            return (Criteria) this;
        }

        public Criteria andZrKmqcEqualTo(String value) {
            addCriterion("ZR_KMQC =", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcNotEqualTo(String value) {
            addCriterion("ZR_KMQC <>", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcGreaterThan(String value) {
            addCriterion("ZR_KMQC >", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcGreaterThanOrEqualTo(String value) {
            addCriterion("ZR_KMQC >=", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcLessThan(String value) {
            addCriterion("ZR_KMQC <", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcLessThanOrEqualTo(String value) {
            addCriterion("ZR_KMQC <=", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcLike(String value) {
            addCriterion("ZR_KMQC like", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcNotLike(String value) {
            addCriterion("ZR_KMQC not like", value, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcIn(List<String> values) {
            addCriterion("ZR_KMQC in", values, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcNotIn(List<String> values) {
            addCriterion("ZR_KMQC not in", values, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcBetween(String value1, String value2) {
            addCriterion("ZR_KMQC between", value1, value2, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andZrKmqcNotBetween(String value1, String value2) {
            addCriterion("ZR_KMQC not between", value1, value2, "zrKmqc");
            return (Criteria) this;
        }

        public Criteria andJeIsNull() {
            addCriterion("JE is null");
            return (Criteria) this;
        }

        public Criteria andJeIsNotNull() {
            addCriterion("JE is not null");
            return (Criteria) this;
        }

        public Criteria andJeEqualTo(BigDecimal value) {
            addCriterion("JE =", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeNotEqualTo(BigDecimal value) {
            addCriterion("JE <>", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeGreaterThan(BigDecimal value) {
            addCriterion("JE >", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("JE >=", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeLessThan(BigDecimal value) {
            addCriterion("JE <", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("JE <=", value, "je");
            return (Criteria) this;
        }

        public Criteria andJeIn(List<BigDecimal> values) {
            addCriterion("JE in", values, "je");
            return (Criteria) this;
        }

        public Criteria andJeNotIn(List<BigDecimal> values) {
            addCriterion("JE not in", values, "je");
            return (Criteria) this;
        }

        public Criteria andJeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("JE between", value1, value2, "je");
            return (Criteria) this;
        }

        public Criteria andJeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("JE not between", value1, value2, "je");
            return (Criteria) this;
        }

        public Criteria andZyIsNull() {
            addCriterion("ZY is null");
            return (Criteria) this;
        }

        public Criteria andZyIsNotNull() {
            addCriterion("ZY is not null");
            return (Criteria) this;
        }

        public Criteria andZyEqualTo(String value) {
            addCriterion("ZY =", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotEqualTo(String value) {
            addCriterion("ZY <>", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyGreaterThan(String value) {
            addCriterion("ZY >", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyGreaterThanOrEqualTo(String value) {
            addCriterion("ZY >=", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLessThan(String value) {
            addCriterion("ZY <", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLessThanOrEqualTo(String value) {
            addCriterion("ZY <=", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLike(String value) {
            addCriterion("ZY like", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotLike(String value) {
            addCriterion("ZY not like", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyIn(List<String> values) {
            addCriterion("ZY in", values, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotIn(List<String> values) {
            addCriterion("ZY not in", values, "zy");
            return (Criteria) this;
        }

        public Criteria andZyBetween(String value1, String value2) {
            addCriterion("ZY between", value1, value2, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotBetween(String value1, String value2) {
            addCriterion("ZY not between", value1, value2, "zy");
            return (Criteria) this;
        }

        public Criteria andBzIsNull() {
            addCriterion("BZ is null");
            return (Criteria) this;
        }

        public Criteria andBzIsNotNull() {
            addCriterion("BZ is not null");
            return (Criteria) this;
        }

        public Criteria andBzEqualTo(String value) {
            addCriterion("BZ =", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotEqualTo(String value) {
            addCriterion("BZ <>", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzGreaterThan(String value) {
            addCriterion("BZ >", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzGreaterThanOrEqualTo(String value) {
            addCriterion("BZ >=", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLessThan(String value) {
            addCriterion("BZ <", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLessThanOrEqualTo(String value) {
            addCriterion("BZ <=", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzLike(String value) {
            addCriterion("BZ like", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotLike(String value) {
            addCriterion("BZ not like", value, "bz");
            return (Criteria) this;
        }

        public Criteria andBzIn(List<String> values) {
            addCriterion("BZ in", values, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotIn(List<String> values) {
            addCriterion("BZ not in", values, "bz");
            return (Criteria) this;
        }

        public Criteria andBzBetween(String value1, String value2) {
            addCriterion("BZ between", value1, value2, "bz");
            return (Criteria) this;
        }

        public Criteria andBzNotBetween(String value1, String value2) {
            addCriterion("BZ not between", value1, value2, "bz");
            return (Criteria) this;
        }

        public Criteria andShIsNull() {
            addCriterion("SH is null");
            return (Criteria) this;
        }

        public Criteria andShIsNotNull() {
            addCriterion("SH is not null");
            return (Criteria) this;
        }

        public Criteria andShEqualTo(String value) {
            addCriterion("SH =", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotEqualTo(String value) {
            addCriterion("SH <>", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShGreaterThan(String value) {
            addCriterion("SH >", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShGreaterThanOrEqualTo(String value) {
            addCriterion("SH >=", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShLessThan(String value) {
            addCriterion("SH <", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShLessThanOrEqualTo(String value) {
            addCriterion("SH <=", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShLike(String value) {
            addCriterion("SH like", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotLike(String value) {
            addCriterion("SH not like", value, "sh");
            return (Criteria) this;
        }

        public Criteria andShIn(List<String> values) {
            addCriterion("SH in", values, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotIn(List<String> values) {
            addCriterion("SH not in", values, "sh");
            return (Criteria) this;
        }

        public Criteria andShBetween(String value1, String value2) {
            addCriterion("SH between", value1, value2, "sh");
            return (Criteria) this;
        }

        public Criteria andShNotBetween(String value1, String value2) {
            addCriterion("SH not between", value1, value2, "sh");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}